Like with the GCSE Media Studies tracker in my shop, this too is all you would need to accurately report grades for your post 16 media studies groups following the LEGACY AQA SPECIFICATION.
There are three tabs included on this spreadsheet depending on the routes being taken by the students in your group:
- Those resitting some AS modules alongside A2 modules. This allows input for all 4 units alongside existing results from Y12. Each unit is broken down into different areas for possible marks and each unit is also converted into an overall grade based on JUNE 2017 boundaries.
- Those only completing A2 units this year. This allows input for unit 3 and 4 broken into each mark, alongside each students certified AS results. Calculations will be made totalling scores from the marks already achieved alongside the new units being completed as the year goes on. Overall A level grades are produced using this data.
- Those students who are only entering for AS Media Studies legacy spec this year with the intention of dropping at the end of the year (otherwise you would be entering them for the NEW spec). Individual boxes are there to enter marks for each question/mark of each component and overall AS grades are calculated based on JUNE 2017 boundaries.
On each tab there is also an additional column - the buffer. Here I have made the boundaries 10% tougher in case of a surprise grade boundary increase in June 2018. This could help identify those who are only just toughing each grade and who may benefit from a few more marks on their coursework or extra revision to ensure they are comfortably into each grade boundary and so avoids any nasty surprises on results day.
I have used these trackers (alongside the ones produced for English) for several years with great success. Not only can you monitor the progress of you group, but they are invaluable when reporting at parents evening and students love to be able to see exactly where they have marks, what grade each unit is on and where they can gain more marks to achieve success.
This tracking sheet really is a must for ALL media departments!
If you do purchase and are happy with my work, please leave a positive review so others are more likely to come across this product in TES searches. If you experience any issues, please contact me at steel123@hotmail.com and I will happily try and resolve it. Likewise, similar trackers are available in my shop for GCSE AQA Media Studies and GCSE 9-1 AQA English Literature and Language. I am in the process of writing trackers for the new 9-1 Eduqas Media Studies as well as AQA English language, English Literature and English Lang and Lit A levels, so subscribe for updates for these subjects.
Enjoy!
NEW AND IMPROVED
This tracker was designed to enable the most accurate and effective data for your SINGLE AWARD GCSE AQA MEDIA STUDIES groups.
Once the data for your group is imputed, the spreadsheet will convert the raw marks given into UMS marks (which vary year on year) and then into grades. Grades will be given for both units separately, as well as an overall grade based on the total marks awarded across the GCSE. NEW FOR SPRING - NOW ALL MARKS ARE CONVERTED TO GRADES FOR EACH PART OF THE COURSEWORK AS WELL; GET THAT INTERVENTION SORTED ASAP!
All conversions are based on actual grade boundaries from the JUNE 2017 exam results.
Please note - grade boundaries are always subject to change as we have found this year in particular and this should only be used as a guide for making accurate predictions. To ensure ultimate success, add a buffer mark on of around 10% higher than this year’s results as a worst case scenario grade.
Lesson exploring context behind friends. Final lesson before mock exam/revision lesson.
Subscribe for further lessons from this specification which will be uploaded as and when they are planned.
NEW TRACKER USING ACTUAL GRADE BOUNDARIES NOW AVAILABLE IN MY STORE
This tracker, as with the others in my store, is designed to make the lives of your A level Media Studies teachers easier, whilst also providing an effective tool for promoting self evaluation in students.
The formula is all in place, all you have to do is export the info from SIMS, copy and paste, then enter the marks for your mocks/assessed pieces as they’re done and as you complete each question, a predicted grade will be offered. When completing a component you will be given an overall predicted grade based on the % of marks that students has achieved.
I have come to the final grade by calculating the % of marks students required in order to achieve each grade on the old spec (different for exam and coursework components). I have then reweighted this based on the number of marks available in the new spec. This, from what I can tell, is the best way of estimating grades on the new specification.
As with all new specifications, this is guesswork. Please approach the grades given with caution and always explain to students/parents/SLT etc that this is simply a best guess until the exam board provide something more conclusive.
The spreadsheet calculates grades for each separate component as well as an overall grade for the qualification. Furthermore, I’ve added a 6 mark buffer to account for grade boundary increases
Any queries or clarification, or any faults with the spreadsheet, please contact me directly at steel123@hotmail.com and I will happily try to repair or resolve any problems.
Happy with your purchase? Please leave a positive review so that this is promoted to others that may benefit!
Includes a column for suggested QA focuses for the year. Editable if you have selected different films from those on the plan.
Currently working on this for teaching from SEPTEMBER. Will be uploading MTPs and lesson packs and when they’re complete - subscribe for updates.
Lessons guiding students through analysis of existing teen dramas (need access to clips on youtube/Netflix) to then storyboarding their own. Looks at narrative structure, character types etc with examples given for both. Doesn’t cover statement of aims. Probably span over 3 or 4 lessons. Storyboard tempate from OLD spec used - can be access through exam board website.
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is lesson one from the scheme of work. Lessons are being planned daily throughout the summer break so please return for updates.
Accompanying Long Term Plan and Medium Term plan available through my shop.
Any questions, please don’t hesitate to ask.
PLEASE NOTE, BACKGROUNDS ON ALL TEXT BOXES SHOULD BE FINE - PREVIEW ON TES DOESN’T MATCH ACTUAL POWERPOINT.
Something I planned to guide students through the planning stages of their coursework. Takes students up to mock ups for DVD cover and Film Poster (doesn’t cover statement of aims).
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is the medium term plan. Lessons are being planned daily throughout the summer break so please return for updates.
Accompanying Long Term Plan and fully resourced lessons available through my shop.
Any questions, please don’t hesitate to ask.
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is lesson four from the scheme of work. Lessons are being planned daily throughout the summer break so please return for updates.
Accompanying Long Term Plan and Medium Term plan available through my shop.
Any questions, please don’t hesitate to ask.
PLEASE NOTE, BACKGROUNDS ON ALL TEXT BOXES SHOULD BE FINE - PREVIEW ON TES DOESN’T MATCH ACTUAL POWERPOINT.
Part of the introductory scheme covering basic elements of film/media analysis using horror extracts as stimuli. This feeds into component 3 and would support learning for any Media or Film Studies course. Also adaptable for KS3 (though extracts would need to be changed for something more age appropriate).
This is a tracker I developed which auto calculates the grades for every assessment year 12 and 13 do throughout the year using actual grade boundaries from the June 2019 examination series. It includes mock exams and overall grades too. Headers can easily be changed if different texts have been chosen.
Hopefully this will save you a lot of time!
Any issues or guidance using needed please email steel123@hotmail.com and I’ll do my best to look into it for you.
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is lesson six from the scheme of work. Lessons are being planned throughout the term so please return for updates.
Accompanying Long Term Plan and Medium Term plan available through my shop.
Any questions, please don’t hesitate to ask.
PLEASE NOTE, BACKGROUNDS ON ALL TEXT BOXES SHOULD BE FINE - PREVIEW ON TES DOESN’T MATCH ACTUAL POWERPOINT.
This bundle is all the resources I used to teach the Submarine unit (minus the textbooks that are occasionally referred to). All resources are editable, all key scenes are on youtube so students can access without several copies of the DVD. Includes powerpoints, song lyrics, key scene screen grabs, structure strips and more.
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is lesson seven from the scheme of work. Lessons are being planned daily throughout the summer break so please return for updates.
Accompanying Long Term Plan and Medium Term plan available through my shop.
Any questions, please don’t hesitate to ask.
PLEASE NOTE, BACKGROUNDS ON ALL TEXT BOXES SHOULD BE FINE - PREVIEW ON TES DOESN’T MATCH ACTUAL POWERPOINT.
As part of my suggested Long Term Plan for the GCSE Film Studies (9-1) course, i will be beginning the course with an introductory unit in which we explore many of the key elements of the course linked to the horror genre. This will then feed into component 3 in which students can produce an extract from a horror film. By including an introductory unit, students will be given opportunity to explore all of the key areas before being shown any of the set texts and so enable a deeper level of analysis when the films themselves are explored. Plus, the component 3 piece will be strengthened with a thorough exploration of the genre, leaving a greater amount of time to focus on planning, filming and editing the coursework itself.
This is lesson eight from the scheme of work. Lessons are being planned throughout the term so please return for updates.
Accompanying Long Term Plan and Medium Term plan available through my shop.
Any questions, please don’t hesitate to ask.
PLEASE NOTE, BACKGROUNDS ON ALL TEXT BOXES SHOULD BE FINE - PREVIEW ON TES DOESN’T MATCH ACTUAL POWERPOINT.